package tables;

public class Badge implements Tables_SUPER {

	private int numBadge;
	private String etatBadge;
	
	public Badge(int numBadge, String etatBadge) {
		this.numBadge = numBadge;
		this.etatBadge = etatBadge.toUpperCase();
	}
	
	@Override
	public String insert() {
		return "INSERT INTO BADGE VALUES(SEQ_BADGE.NEXTVAL,'"+etatBadge+"')";
	}
	@Override
	public String update() {
		return "UPDATE BADGE SET ETATBADGE='"+etatBadge+"' WHERE NUMBADGE="+numBadge;
	}
	@Override
	public String delete() {
		// TODO Auto-generated method stub
		return null;
	}

	//getter & setter
	public int getNumBadge() {
		return numBadge;
	}

	public void setNumBadge(int numBadge) {
		this.numBadge = numBadge;
	}

	public String getEtatBadge() {
		return etatBadge;
	}

	public void setEtatBadge(String etatBadge) {
		this.etatBadge = etatBadge;
	}
	
	
	
}
